Note: In order to use the spreadsheet examples, you need to download Business Functions, except where it says 'Non Business Functions' which just uses plain Excel. | |
Capital Value | |
In the UK its common to use yield to value real estate, and where there are stepped rents the layer method (an extension of yield) is used. This worksheet uses a single Business Function, CapValueGD, to apply the layered yield method to calculate a property value, using either a True or Equivalent Yield. | |
Download: capvalue.xls | |
Screenshot |